package com.smartEdu.mapper.common;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import com.smartEdu.commons.BaseMapper;
import com.smartEdu.po.HomeWorkRecordPo;

public interface HomeWorkReportMapper  extends BaseMapper<HomeWorkRecordPo> {
	@Select("select a.SID,b.Answer,b.answerlist from (select SID from course_student_${academic} where AutoID = (select src_id from hwork_info where PK = #{pk})) a left join hwork_record b on a.SID = b.SID")
	public List<HomeWorkRecordPo> findStatistics(@Param("academic") String academic, @Param("pk") String pk);
	@Select("SELECT SID,answer,answerlist FROM hwork_record WHERE PK = #{pk}")
	public List<HomeWorkRecordPo> findDetaileReport(@Param("pk") String pk);
}
